UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dj5wZHfvgHBh8pJofZMRjNcwaocOtOE0ceiGf6gTi04='
WHERE
key_id = '6a27883195eb5ca30e358c5dc68a32c8efd062f1f7343ab03cc9e763920e69ac'
AND (
token = 'dj5wZHfvgHBh8pJofZMRjNcwaocOtOE0ceiGf6gTi04='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)