UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JZOq7LtTAEnd4lFgg9gkUNTsTZK2tZ1FPSWUS50XWcY='
WHERE
key_id = '7018c6522dc50686e6ca773e8a422ae2d694a221ab7c2d2b8c543cce5dc55804'
AND (
token = 'JZOq7LtTAEnd4lFgg9gkUNTsTZK2tZ1FPSWUS50XWcY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)