UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pH/124iSjYJ2CMQ4VNxR6xqzW8bGf9VMMqLqzqUrZBo='
WHERE
key_id = '7c612b1592e8e2d542cc4cff890603010a0e49be4aee70be77def51b26fb46a0'
AND (
token = 'pH/124iSjYJ2CMQ4VNxR6xqzW8bGf9VMMqLqzqUrZBo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)