UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WSIIDHG61/jf0aXEiXCCX2g9RopP3Dmehd3aR8lrBIU='
WHERE
key_id = '918f40026ae4c42256dd394b8488c77e6fb5305b597982fcbe4c71ed0007a607'
AND (
token = 'WSIIDHG61/jf0aXEiXCCX2g9RopP3Dmehd3aR8lrBIU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)