UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P9WgM7TsCXr0QyV/r/CBF5HADwduQrLKFjtgWz9QLic='
WHERE
key_id = '3e0b6f4a20014cfb657ad0a2e764e5d6a6405039568e2442cef42ece27755bd4'
AND (
token = 'P9WgM7TsCXr0QyV/r/CBF5HADwduQrLKFjtgWz9QLic='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)