UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bcpf1OXPl1023e/MMEf9/JTl4MPkxN5TUDceJn4avX8='
WHERE
key_id = 'd220ac1d30abc2d644466ab8c82d15feecd4010213b3e86d3983033cce99dcf1'
AND (
token = 'bcpf1OXPl1023e/MMEf9/JTl4MPkxN5TUDceJn4avX8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)