UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'c2H7KFXz6r2xzqeA+YMwTVRbKjqjshpgV+tfF4Jpqh4='
WHERE
key_id = '93837d59b8d438f705bd16140f7548bd43d928e7769b5e3f0960c36a984f1213'
AND (
token = 'c2H7KFXz6r2xzqeA+YMwTVRbKjqjshpgV+tfF4Jpqh4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)