UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BrtBnGRQ3xH8uo+URARjNv1cUCA8UDP5WOM6A/fNwy0='
WHERE
key_id = 'bc2bbaffb3c16f7b82fa817223ca61976975770e36a0e74add664132e254442f'
AND (
token = 'BrtBnGRQ3xH8uo+URARjNv1cUCA8UDP5WOM6A/fNwy0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)