UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0D4GpoPjRJgkuVbcZmH35JI/SqCwFnNXxs5h9yH74bc='
WHERE
key_id = '17b0df7c8be3c37711736537f915d6f1d00989051e7181f5ba9308cd73530ce3'
AND (
token = '0D4GpoPjRJgkuVbcZmH35JI/SqCwFnNXxs5h9yH74bc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)