UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Dq9i2ldjTtjQ8H03nI3LmcCdBa+fSiEIC6m5PaooCms='
WHERE
key_id = 'e2a757dd8fd4d4cc31e4a35629f508ed12e1ad5d6f35e8b524c20cdb0ac5b36a'
AND (
token = 'Dq9i2ldjTtjQ8H03nI3LmcCdBa+fSiEIC6m5PaooCms='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)