UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MS9dDzdRL3N79wNfmYIgkO7vPcPUYGglaYMKY0Ftx1k='
WHERE
key_id = '6b6449dec051403ee648c103abd8d94898441b969a39529b88a0cd231b53dc7a'
AND (
token = 'MS9dDzdRL3N79wNfmYIgkO7vPcPUYGglaYMKY0Ftx1k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)