UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z59+OX5KBEXvjyl7mp+PhPDKGEAfTWK68eF2iAr1SO0='
WHERE
key_id = 'dffd27a937f3b79ca3c13cedc19a5d936d985120a804e59c43c6edf51e8f4007'
AND (
token = 'Z59+OX5KBEXvjyl7mp+PhPDKGEAfTWK68eF2iAr1SO0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)