UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'phhnrUH2cMTfQtwYHF67wgpaY83pT0WDHTY9xiUOuww='
WHERE
key_id = '2dc0d6678bc22486865af05f084f5f8820a6aa995f5f47d6ba7c9a7f4217e742'
AND (
token = 'phhnrUH2cMTfQtwYHF67wgpaY83pT0WDHTY9xiUOuww='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)