UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'L1Gyk0q0YijNdw6j2SrsgjVB6DUISF14c0EuMD9uIUA='
WHERE
key_id = 'ff80aeb15e9a2a073a489d756be8d75cfa5080c7057e3e984f5fac2e709ac9c4'
AND (
token = 'L1Gyk0q0YijNdw6j2SrsgjVB6DUISF14c0EuMD9uIUA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)