UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9zcpMHoXb1luc3IRz0aVbaITvSc7sLowYaEyDrt9AO0='
WHERE
key_id = 'fa723488dde5359eeba1095baac32bcecbe708f68d4c19c703ea854e91eabc6e'
AND (
token = '9zcpMHoXb1luc3IRz0aVbaITvSc7sLowYaEyDrt9AO0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)