UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6zddkmi/aVpIbv47eOY5lFk3Om2TkBQCzkwGwpf2Vgg='
WHERE
key_id = 'ef96272a04ebda71fde15ed9c88932489b78df88996e87e5ed8665fcb8fcbddd'
AND (
token = '6zddkmi/aVpIbv47eOY5lFk3Om2TkBQCzkwGwpf2Vgg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)