UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Y4p0PWhR3ZtBmeWx4m5hmtP5UAVb6qMPs7R3jpQagX0='
WHERE
key_id = '578830c5df12c1ff4f0ebf0a9adc80a32b6457100508eecb1af51e530f1ad9f2'
AND (
token = 'Y4p0PWhR3ZtBmeWx4m5hmtP5UAVb6qMPs7R3jpQagX0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)