UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Nl+R3chz7mCRXGBFKgT2YY2iW6iscHWMG+UBKyeG1Ls='
WHERE
key_id = 'c346289312c315eb3e4e7e68b33d9f7d272d75001a2067f86fc69b5d1b3eeb3b'
AND (
token = 'Nl+R3chz7mCRXGBFKgT2YY2iW6iscHWMG+UBKyeG1Ls='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)