UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6f4ND6R72e7DAcrmL3ggzBCxE4Bm0giJiTggW2WRxIw='
WHERE
key_id = '5e3808a21b0c4de64c83e6956331da2464786f2819b2cfc2acb3e25d665ed2f2'
AND (
token = '6f4ND6R72e7DAcrmL3ggzBCxE4Bm0giJiTggW2WRxIw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)