UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 't8GrUgBUAN04Ze4c+jge4vBDfxSa6027AubqztbkZXI='
WHERE
key_id = 'dff4c04b1f666d1a887912223155a3e194adfa2242edf6eefea83c5a155124e4'
AND (
token = 't8GrUgBUAN04Ze4c+jge4vBDfxSa6027AubqztbkZXI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)