UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'L6aCE9dIdt1MZBAt3XDFyil/tcAhRjnY9PUEzivULCA='
WHERE
key_id = 'df1de8e4063093cc5fbe3d6001155b22b34bc4fa7f45f32b6b410d63d0598a68'
AND (
token = 'L6aCE9dIdt1MZBAt3XDFyil/tcAhRjnY9PUEzivULCA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)