UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MrgvXmfMmtZItNIkQjnvLqC/hqTlV7mzKqzaldpib+8='
WHERE
key_id = '1b048c02aaa115236c369193d4da78a8ee67fe877217a014b8a65d8ed5e6a42d'
AND (
token = 'MrgvXmfMmtZItNIkQjnvLqC/hqTlV7mzKqzaldpib+8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)