UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rMiXchJJ+20W26UZhKGA4NRiAj7PIwPYdY9w+YDbgsI='
WHERE
key_id = '6ca0e65857bf34b75be6df6f5f35675cfe3537c4973ff41beb6fbc4f19aeac28'
AND (
token = 'rMiXchJJ+20W26UZhKGA4NRiAj7PIwPYdY9w+YDbgsI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)