UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CiHg0WmY0VJcGXt30cG2hlJjz86i2SFlmNlOw6rg/J4='
WHERE
key_id = '84ec151b4435a44b499dc2b5d60ea6ddce186863dbe86be7b164a872accbb287'
AND (
token = 'CiHg0WmY0VJcGXt30cG2hlJjz86i2SFlmNlOw6rg/J4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)