UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x65av8tVUqx8T24FhPj+qXv/yRhgzJZFWvvOCZFCFjY='
WHERE
key_id = 'fda40e8ccb43c53f3ad4bd97da005430e262c18f6e8e32be99151d9a99aff703'
AND (
token = 'x65av8tVUqx8T24FhPj+qXv/yRhgzJZFWvvOCZFCFjY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)