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