UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3g0uZAlJurm3mEpjIwr7Z6gDRtPSGHm7vBXwTzVgRC0='
WHERE
key_id = '878620e47e41ee73ee91878a4e9729825976be46243f3e6420869e4c4668adce'
AND (
token = '3g0uZAlJurm3mEpjIwr7Z6gDRtPSGHm7vBXwTzVgRC0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)