UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EgMlbKSISetkQoZ0c2TKcsCIDZUiVta3ySOWe7XxSB4='
WHERE
key_id = '8c19aa1a358ad3dd4c514a8cb2400c0094e7467b47b0d7773d30fd8ff8f883c4'
AND (
token = 'EgMlbKSISetkQoZ0c2TKcsCIDZUiVta3ySOWe7XxSB4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)