UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8t0ecAZDImPe8KttfLy3iJSG7f/YkJYkBhlDCWwEhxQ='
WHERE
key_id = 'cd5bb30a22759003e2eb289e3583cccdca9e0d7c41d6c9b26b291078c0b6d278'
AND (
token = '8t0ecAZDImPe8KttfLy3iJSG7f/YkJYkBhlDCWwEhxQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)