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