UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BXZ0IJDHnQ+1n+bqqHPDG5nCdmd2twsQUosSZoP5rPI='
WHERE
key_id = 'b2efa092090517067eb81f6e3676dca29de9c84e7ec2ae63bd30bd42ecaa432e'
AND (
token = 'BXZ0IJDHnQ+1n+bqqHPDG5nCdmd2twsQUosSZoP5rPI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)