UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gxZKq0Vyb9ICfCeP7wV3UbaNyJd5xONJqDg6pFUa2H4='
WHERE
key_id = '71beddd470c2aa3b21f4adfd75e7dbc1a411243d5887a7f46e15b3c056595793'
AND (
token = 'gxZKq0Vyb9ICfCeP7wV3UbaNyJd5xONJqDg6pFUa2H4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)