UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XizMxLzQo1FnBgSjqssYYRCnu1yquEQT5Jg446iTZIQ='
WHERE
key_id = '786cb179753d9b1c42961e7a705fd08f8ad9e8d4382f72949ccef40e709f6e56'
AND (
token = 'XizMxLzQo1FnBgSjqssYYRCnu1yquEQT5Jg446iTZIQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)