UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vnkcmdm8fSEMSZTZHWr20Jso6tLFW9M/ZA1KPDrQ5oU='
WHERE
key_id = 'd0baf867ede87589a88b84940318b253d1cc1a9d200b8bf6d23ff0ac6cca8172'
AND (
token = 'vnkcmdm8fSEMSZTZHWr20Jso6tLFW9M/ZA1KPDrQ5oU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)