UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z5+r9xtoONbpMoN8hDfrxjKXD8sPyrjPuZqvqm+/ynw='
WHERE
key_id = '1e4d1c191491983c6511962624ac160a0b061317305cbd278b089be26757f826'
AND (
token = 'Z5+r9xtoONbpMoN8hDfrxjKXD8sPyrjPuZqvqm+/ynw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)